Steps to Configure DTC

1. Enable "DTS Services" on the SQL Server hosting the FMIS/Integration database. Refer to Figure 1. 
   1. Navigate to "Administrative Tools - Component Services - Services (Local)" on the machine.
   2. Search for "Distributed Transaction Coordinator"
   3. Right on the services and go the "Properties". This will open a form with the service name as "MSDTC".
   4. Set the "Startup Type" to "Automatic".
   5. Enable the service.  Click on "Start" the service in the left section. Refer to Figure 2 and Figure 3.
2. Configure the Firewall on both SQL Servers to allow DTC for all 3 (RPC, RPC-EPMAP, TCP-IN) in the Inbound and Outbound Rules. Refer to figure 2 below
   1. Navigate to "Administrative Tools - Windows Defender Firewall with Advanced Security".
   2. Go into "Inbound and Outbound" rules.
   3. Search for "Distributed Transaction Coordinator" .
   4. Enable the rule. Click on the "Enable Rule" option in the right panel.
3. Enable DTC security controls. Refer to Figure 4.
   1. Navigate to "Administrative Tools - Component Services - Computers - My Computer - Distributed Transaction Coordinator".
   2. Right-click on "Local DTC", select "Properties" and set the options shown in figure 3 on both SQL Servers machines.
4. Restart both machines.

Figure 1: Enable DTS Services

Figure 2: Firewall Configure - In Bound Rule

Figure 3: Firewall Configure - Out Bound Rule

Figure 4: Component Services Configuration